Problem Note 64105: Basic authentication is not supported in SAS/ACCESS® Interface to the PI System under Linux
SAS/ACCESS Interface to the PI System under Linux currently supports only the none and Kerberos authentication methods. It does not support the basic authentication method to connect to PI Servers.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Post Hot-Fix Instructions
This hot fix requires that you install another hot fix, which supports the environment variable SAS_PI_WEB_AUTH. For more information, see SAS Note 64004, "You encounter slow performance when you use SAS/ACCESS® Interface to the PI System under Linux to connect to PI Servers."
You can set the environment variable, SAS_PI_WEB_AUTH, to use basic authentication by running the following SAS code:
options set=SAS_PI_WEB_AUTH "BASIC";
Then, you can specify and run your LIBNAME statement using syntax similar to either of the following examples:
libname db pisystem host='pi-webapi-host' server='pi-server' domain='your-domain' user='your-id' password='your-password';
libname db piaf host='pi-webapi-host' server='pi-af-server' database='your-database' domain='your-domain' user='your-id' password='your-password';
Notes:
- Make sure that your target PI Web API host is configured with the basic authentication method.
- If your PI Web API host is configured to allow an authentication method other than basic, SAS might connect using your other authentication method. In this scenario, some option values such as domain, user-id, and password might be ignored.
This issue is fixed in the SAS® 9.4M6 (TS1M6) April 2019 release.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to the PI System | Solaris for x64 | 9.43 | 9.44 | 9.4 TS1M5 | 9.4 TS1M6 |
64-bit Enabled Solaris | 9.43 | 9.44 | 9.4 TS1M5 | 9.4 TS1M6 |
64-bit Enabled AIX | 9.43 | 9.44 | 9.4 TS1M5 | 9.4 TS1M6 |
Linux for x64 | 9.43 | 9.44 | 9.4 TS1M5 | 9.4 TS1M6 |
HP-UX IPF | 9.43 | 9.44 | 9.4 TS1M5 | 9.4 TS1M6 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
SAS/ACCESS Interface to the PI System under Linux currently supports only the none and Kerberos authentication methods. It does not support basic authentication to connect to PI Servers.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-05-20 15:46:03 |
Date Created: | 2019-04-25 09:57:20 |